---
title: DB-CLL-059 — Fetch the maximum assignment result sequence
summary: Fetch the maximum assignment result sequence
status: draft
owner: SAIF Case Management team
last_reviewed: 2026-08-21
library: SAIF.Business.Claim.Legal
reference_type: embedded
---

# DB-CLL-059 — Fetch the maximum assignment result sequence

## Classification

| Field | Value |
|---|---|
| SQL ID | DB-CLL-059 |
| Operation type | Misc |
| Execution method | Text |
| Database | Oracle (Case Management) |
| Schema | [unqualified]** |
| Command type | Inline text SQL |
| Business object | clsAssignmentProcess.GetMaxSeq |
| Criteria property | n/a (custom method) |
| Lifecycle method | n/a |

## Parameters

No bound parameters were identified for this statement.

## Tables

| Table | Access | Columns/Notes |
|---|---|---|
| [pk80005_assignment (package function target unknown)](../database-tables.md#pk80005_assignment-related-table(s)-(unidentified)) | SELECT | unknown** |

## Sample SQL

```sql
select
  pk80005_assignment.max_result_seq
from
  dual
```

## Operations and processes

- [Review attorney assignment calendar](../operations/review-assignment-calendar.md)

## Sources

- `SAIF.Business.Claim.Legal\LegalNet\clsAssignmentProcess.vb`